/*
 Navicat Premium Data Transfer

 Source Server         : 172.16.24.150
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : 172.16.24.150:3306
 Source Schema         : viewer

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 24/10/2020 12:37:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'admin@admin.com', '13080809090', '2020-10-20 03:45:54', '2020-10-20 03:45:54');
INSERT INTO `user` VALUES (2, 'jack01', 'e10adc3949ba59abbe56e057f20f883e', 'jack01@lagou.com', '13112341234', '2020-10-21 05:50:54', '2020-10-21 05:50:54');
INSERT INTO `user` VALUES (3, 'jack02', '4297f44b13955235245b2497399d7a93', 'jack02@lagou.com', '13109097890', '2020-10-21 05:51:38', '2020-10-21 05:51:38');
INSERT INTO `user` VALUES (4, 'jack03', '4297f44b13955235245b2497399d7a93', 'jack03@lagou.com', '13112341112', '2020-10-21 05:52:19', '2020-10-21 08:27:56');
INSERT INTO `user` VALUES (5, 'jack05', '4297f44b13955235245b2497399d7a93', 'jack05@lagou.com', '13198987000', '2020-10-21 08:02:40', '2020-10-21 08:28:20');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
